package dao;


import pojo.QueryVO;
import pojo.SC;
import pojo.Student;
import pojo.StudentGrade;

import java.util.List;

public interface StudentMapper {

	
	//遵循四个原则
	//接口 方法名  == User.xml 中 id 名
	//返回值类型  与  Mapper.xml文件中返回值类型要一致
	//方法的入参类型 与Mapper.xml中入参的类型要一致
	//命名空间 绑定此接口
	Student findStudentBySno(String sno);
	Student findStudentBySname(String sname);
	void insertStudent(Student student);
	void updateStudent(Student student);
	void deleteStduentBySno(String Sno);
	List<Student> queryStudentAll();
	List<Student> queryStudentByWhere(Student student);
	List<Student> queryStudentBySnos(QueryVO queryVO);
	List<StudentGrade> queryStudentGrade();
	List<SC> querySCStudentResultMap();
	List<Student> queryStudentSC();
}
